www.gusucode.com > 帝国网站管理系统(帝国CMS) 6 > 帝国网站管理系统(帝国CMS) 6.5繁体UTF-8/upload/e/admin/workflow/ListWfInfo.php
<?php define('EmpireCMSAdmin','1'); require('../../class/connect.php'); require('../../class/db_sql.php'); require('../../class/functions.php'); require '../'.LoadLang('pub/fun.php'); require('../../data/dbcache/class.php'); $link=db_connect(); $empire=new mysqlquery(); $editor=1; //驗證用戶 $lur=is_login(); $logininid=$lur['userid']; $loginin=$lur['username']; $loginrnd=$lur['rnd']; $loginlevel=$lur['groupid']; $loginadminstyleid=$lur['adminstyleid']; $page=(int)$_GET['page']; $start=0; $line=intval($public_r['hlistinfonum']);//每頁顯示 $page_line=12;//每頁顯示鏈接數 $offset=$page*$line;//總偏移量 $add=" and (groupid like '%,".$lur[groupid].",%' or userclass like '%,".$lur[classid].",%' or username like '%,".$lur[username].",%')"; $totalquery="select count(*) as total from {$dbtbpre}enewswfinfo where checktno=0".$add; $num=$empire->gettotal($totalquery); $query="select id,classid,tstatus,checktno from {$dbtbpre}enewswfinfo where checktno=0".$add; $query=$query." order by id desc limit $offset,$line"; $sql=$empire->query($query); $returnpage=page2($num,$line,$page_line,$start,$page,$search); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <link href="../adminstyle/<?=$loginadminstyleid?>/adminstyle.css" rel="stylesheet" type="text/css"> <title>管理簽發信息</title> </head> <body> <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1"> <tr> <td height="25">位置:<a href="../ListAllInfo.php">管理信息</a> > <a href="ListWfInfo.php">管理簽發信息</a></td> </tr> </table> <br> <table width="100%" border="0" align="center" cellpadding="3" cellspacing="1" class="tableborder"> <form name="form1" method="post" action=""> <tr class="header"> <td width="6%" height="25"> <div align="center">ID</div></td> <td width="46%" height="25"> <div align="center">標題</div></td> <td width="9%"><div align="center">狀態</div></td> <td width="13%"><div align="center">發佈者</div></td> <td width="16%"><div align="center">提交時間</div></td> <td width="10%" height="25"> <div align="center">操作</div></td> </tr> <?php while($r=$empire->fetch($sql)) { if($class_r[$r[classid]][tbname]) { $nr=$empire->fetch1("select title,newstime,userid,username,ismember from {$dbtbpre}ecms_".$class_r[$r[classid]][tbname]." where id='$r[id]'"); } $do=$r[classid]; $dob=$class_r[$r[classid]][bclassid]; //狀態 $st=''; if($r[checktno]=='100') { $st='審核通過'; } elseif($r[checktno]=='101') { $st='返工'; } elseif($r[checktno]=='102') { $st='已否決'; } else { $st=$r[tstatus]; } //發佈者 if($nr[ismember]) { $username=empty($nr[userid])?'遊客':"會員:<a href='member/AddMember.php?enews=EditMember&userid=".$nr[userid]."' target='_blank'>".$nr[username]."</a>"; } else { $username="<a href='user/AddUser.php?enews=EditUser&userid=".$nr[userid]."' target='_blank'>".$nr[username]."</a>"; } ?> <tr bgcolor="#FFFFFF" onmouseout="this.style.backgroundColor='#ffffff'" onmouseover="this.style.backgroundColor='#DBEAF5'"> <td height="25"> <div align="center"> <?=$r[id]?> </div></td> <td height="25"> <a href="ShowWfInfo.php?classid=<?=$r[classid]?>&id=<?=$r[id]?>" title="查看內容" target="_blank"><?=$nr[title]?></a> <br> 欄目:<a href='ListNews.php?bclassid=<?=$class_r[$r[classid]][bclassid]?>&classid=<?=$r[classid]?>'> <?=$class_r[$dob][classname]?> </a> > <a href='ListNews.php?bclassid=<?=$class_r[$r[classid]][bclassid]?>&classid=<?=$r[classid]?>'> <?=$class_r[$r[classid]][classname]?> </a> </td> <td><div align="center"><?=$st?></div></td> <td><div align="center"><?=$username?></div></td> <td><div align="center"> <?=date("Y-m-d H:i:s",$nr[newstime])?> </div></td> <td height="25"> <div align="center">[<a href="#ecms" onclick="window.open('DoWfInfo.php?classid=<?=$r[classid]?>&id=<?=$r[id]?>','','width=600,height=520,scrollbars=yes');">簽發</a>]</div></td> </tr> <? } ?> <tr bgcolor="#FFFFFF"> <td height="25" colspan="6"> <?=$returnpage?> </td> </tr> </form> </table> </body> </html> <? db_close(); $empire=null; ?>